SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030102 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030102 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503877,87478,1014693,1009048,361733,552095,876932,694470,980975,140565,885660,497202,1002325,906405,38718,777952,413656,756225,28893,168845,103154,292921,778545,50729,577023,774487,505060,321026,455322,1024730,350690,332514,931434,1021789,537679,375817,756908,235699,116566,18416,1033355,892558,56686,780891,166094,198586,266869,832136,812093,344744,901495,1045767,895790,168192,735031,848839,786100,522835,618310,201262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]