SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422994 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422994 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398836,675820,228734,459768,858979,533662,489131,26026,1025980,146968,674720,643605,908296,22637,915144,114841,573902,470840,413029,332273,90828,1017015,385703,703535,465774,441678,804388,517453,672807,618313,540985,171883,993634,486873,733569,291534,694085,315444,1046566,641721,987198,717504,878969,706311,61792,44000,65161,326012,878721,40798,1012192,591672,107413,586349,648004,180115,523516,703660,779034,96645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]