SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111400 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111400 [ RunTime:0.001428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629204,109198,638776,1017665,137648,180759,932629,438468,291386,614424,216364,884983,501654,448321,895294,148988,897266,105040,183500,622073,114368,287280,318803,485420,244925,279214,296659,890935,986642,401020,6179,382687,186832,832410,174068,331703,468592,938553,500445,503358,1042227,706491,806200,624913,279587,49109,421375,610122,894482,506068,315371,790606,738140,495762,69129,970552,641505,222468,390180,320721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002659s ]