SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437809 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437809 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034195,363592,417333,860247,410425,385738,23690,411809,907305,802525,81831,337084,805381,761028,868437,959350,880452,61905,185493,766671,331103,442215,884348,1031404,557625,266434,135176,964791,925659,751774,310636,442785,109295,868018,351880,447807,335153,230130,319514,205304,349933,503641,971701,700711,490680,527131,51146,963007,63198,515486,437221,405661,320162,423265,266256,177075,432178,434828,224509,992400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]