SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368983 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368983 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257774,395034,371775,214413,32136,572697,24907,774256,721407,345869,237139,555067,914406,619508,747600,178047,559210,764571,276107,383948,202297,393144,280515,242601,330032,127926,227581,1040099,832811,986277,796546,182423,458753,621552,514945,889760,570933,994365,764287,539424,812414,367520,316167,136980,164116,350196,257561,386607,577427,270827,121756,977301,279087,672364,637976,51070,915246,969919,635900,485690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]