SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525099 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525099 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809336,244056,744099,315255,463606,651371,230018,485337,154199,36051,186734,428207,931493,765499,350424,816039,534772,347171,997012,793602,298233,443175,127762,632558,54943,642375,394966,450670,466025,531865,1019653,1016286,439509,194861,686619,545651,593234,811005,695030,427886,529443,212352,513317,1023160,932191,227208,192083,247687,784303,162456,127561,108926,338038,203424,687228,53886,706373,150226,412171,1032908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002540s ]