SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403962 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403962 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000524,240564,15081,662570,574707,518093,563665,912958,475000,528229,639248,245037,59434,265415,525416,252779,587654,1006785,261609,849294,765941,762398,65112,919481,480254,128019,383228,820729,516841,633925,1017487,424887,937585,488293,227643,783368,945199,251547,778194,702879,332340,52141,370498,547810,827835,37257,124256,535929,877353,604300,752913,863539,393168,440762,991416,552234,922996,695843,681558,268820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001914s ]