SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324151 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324151 [ RunTime:0.002315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425836,888881,848251,101149,387576,771799,45424,905737,494278,862717,273735,682215,240283,1025902,959708,795833,436601,133083,988141,866696,892545,879558,594866,48023,998829,662822,789671,879022,1038163,921212,550989,108644,101801,434779,562905,720126,906118,95314,141220,49309,332740,381203,311198,945825,796406,894158,884936,494953,917488,662868,40734,411319,106747,158956,721204,638712,924585,22677,601064,494557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]