SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348580 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348580 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922825,181579,866893,106803,743986,301084,888959,945336,549518,640943,297199,810245,858947,900169,464201,686274,15752,966050,683526,765160,344226,997147,1015900,611428,248207,401388,442517,106484,858722,834028,371590,380563,592958,609269,529330,751596,302059,333898,132376,602202,963880,910549,513908,960289,1048847,473767,10665,296216,1033605,324269,518277,563534,654667,444073,393855,148882,322371,350076,281645,374530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001168s ]