SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036397 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036397 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842502,604443,281178,63109,275256,421039,534239,106870,670808,680994,1034910,758088,856484,20862,148116,203143,7637,64913,112545,987930,652145,267582,764917,877498,853084,16750,359014,201962,64358,788334,260938,239157,1023260,363450,705917,845298,89530,210839,315911,568075,52175,925060,795373,871531,582351,626543,323340,362956,664064,750712,4785,747283,896903,1022102,971953,49674,116806,1028270,825388,116679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]