SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520633 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520633 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368123,775010,168313,33627,662231,922783,1007910,827859,785819,218381,571685,16774,238178,668258,419036,593106,1022203,236796,1012844,529575,587543,639584,436630,374623,693637,129974,865875,820823,236802,892866,384850,918189,198358,515041,132009,334411,865782,589009,725355,430228,351714,859066,738890,145526,424907,480998,697496,1045171,407472,31602,342551,1013951,659110,299492,294121,322342,575308,658034,947876,919722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]