SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 715023 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 715023 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565518,374917,949367,1008727,711024,363909,782130,879004,433082,683822,21181,458413,1009065,770924,39286,890773,671646,748567,128202,661504,518443,502722,197265,504684,283777,73135,496698,829242,487153,1002643,61060,287019,565530,629143,616970,428320,729575,844492,335851,591433,348223,862091,709588,1021932,544194,779012,920086,452604,45449,733639,335839,280328,700084,433188,736045,6334,989818,721207,308226,96427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 715023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 715023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004396s ]