SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551711 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551711 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792389,1048458,593424,314917,127154,132094,838997,788719,286634,402184,488700,155236,583246,859287,252534,307290,547916,522393,537275,216961,915765,709467,790860,1019283,429758,49972,947240,195973,575977,16774,829948,507504,1032008,144563,498598,322828,1009487,577679,455841,1014680,449914,683222,761107,773468,480334,864621,651833,340159,762412,685232,771825,860228,408619,762792,565996,926781,374143,446996,198354,113854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]