SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331098 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331098 [ RunTime:0.005286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324007,832076,311461,885952,125508,599850,8731,697669,989548,986411,981635,481613,337833,937055,213421,425191,820025,441119,173809,870698,673289,451696,977371,285501,817188,337004,849034,254192,950875,84375,516364,19204,387955,927901,673383,515912,536825,61973,991140,520997,360673,796389,997233,248035,836569,167341,364351,1024069,552627,929907,56014,157980,486478,688067,97732,280583,648290,754322,750318,738238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]