SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429103 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429103 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802645,606954,22096,975858,778380,436384,1013914,775340,49901,394170,476927,252365,551328,147582,311255,563956,247143,1044257,645566,379102,362580,371896,389700,1035480,558033,893689,1004707,150808,955450,157056,396590,789166,61282,1024812,397633,399049,489939,276572,996195,318863,467366,919348,628847,312901,310205,725531,159331,315078,863516,718859,607323,284364,1010670,469357,646744,113650,390092,957079,212213,579217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]