SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555031 LIMIT 1 [ RunTime:0.000759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555031 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009427,8844,761706,836034,921226,557601,320954,635499,161499,130991,452220,359360,669277,115888,478541,194479,383559,823816,444831,100584,888626,390276,866123,849244,173156,816822,622952,178939,1027455,294137,301824,662813,359830,936327,390312,632655,582877,330817,282742,675671,657457,709975,674198,519273,128448,1044434,906008,47885,859363,275491,738501,241904,410208,800735,868336,389285,402503,129252,406366,123824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]