SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53101 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53101 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937065,1020189,492997,850573,606242,909004,406584,436914,871106,87187,865204,660703,911756,234716,969266,252590,656361,645942,17395,215981,187288,780012,935508,287068,823678,975015,838538,298481,425159,497515,485989,1035273,422272,36327,931287,172370,854463,778113,679973,16977,149636,4499,260799,901110,853001,564961,562562,492805,203921,746087,184225,666878,226863,458804,511311,622802,1000338,852597,606100,807551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001852s ]