SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450189 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450189 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371421,292743,489359,715803,573325,4771,256824,765179,140230,26632,69211,783481,994086,1025853,98143,262610,1014948,368860,184236,956545,950425,600916,218272,690722,622792,249875,370101,764135,26747,717977,320006,17792,685973,786385,842773,569371,208160,1014974,292415,435953,381678,661770,532699,12463,110210,751090,887172,569980,796965,127537,208163,1012582,37551,393793,399446,216158,312736,428235,263376,699818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]