SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402574 LIMIT 1 [ RunTime:0.000660s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402574 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918912,722,105752,635246,436324,902076,36897,979570,600920,80120,693570,792870,796134,583306,854504,1019902,295256,784659,44036,779559,553512,211989,1039943,130863,1001622,163059,154470,882806,971398,849961,952083,37121,406702,48399,383119,276207,609063,547138,359890,50016,424568,485464,549545,482255,274385,262050,361913,387150,885505,259895,1013541,999571,952710,41903,537826,415954,771621,867283,1024130,304528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]