SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417015 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417015 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670879,757161,531211,932856,1005955,302960,363704,746729,891626,116366,293367,569448,597845,444778,784461,132707,281745,1048799,602892,329127,572402,755125,702715,400355,86368,570166,663096,174464,915541,586867,159787,111700,1014305,16715,258715,72175,93690,233360,845472,419586,767038,427792,222266,529878,852692,650263,205241,357279,664463,118585,904288,856596,419259,64446,97963,438085,263838,842240,190456,373040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]