SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901243 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901243 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948011,1002385,903664,147741,129936,744513,392788,210768,918204,491750,21022,356190,696190,607912,18177,604264,561002,642096,475504,19151,97121,35742,1041362,654998,85454,1042830,488644,737490,625291,161416,968948,400113,579279,304906,900301,877317,411614,470765,94577,804668,520788,675610,59136,285486,947704,1033082,7213,730850,1033897,1016928,464236,956828,924641,897850,415552,471594,703552,23361,100488,812661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]