SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492226 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492226 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129047,870813,774138,48833,1019979,169601,879131,985,571170,453813,901312,1008532,49280,305643,128996,797835,448170,408713,1003060,800125,880803,404846,525420,149371,210541,26986,922448,222440,896671,854617,604508,1024381,250120,763039,976248,856615,117862,485063,23885,616370,3048,514496,686487,855672,800910,265868,351313,4861,472889,511684,945026,382793,106776,574889,590052,415186,1015952,161156,771384,338489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]