SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504243 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504243 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226744,125967,496997,438153,399136,637739,812255,954016,635887,380678,206501,792245,639828,569950,508524,886936,712611,544435,379153,577688,618238,422681,320075,841575,973975,652006,259202,740145,710575,361781,770221,139311,836251,22179,857314,258431,710477,151611,921501,518257,215876,941037,764024,579586,484152,1022845,1046168,202980,589284,920747,940681,90451,869212,986534,892103,965404,421213,840865,931059,799102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]