SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003910 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003910 [ RunTime:0.003544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805309,585418,869330,1033521,535311,732344,316806,548741,129967,897405,352822,692574,295825,447915,194563,900128,71662,127680,706623,494600,430507,155138,716232,722990,183762,842078,900497,600923,686991,658782,864847,678953,536032,137878,410354,83741,132850,274841,282223,986285,884378,105586,410856,891661,72269,375426,698316,816868,49164,480118,138084,392142,24374,214219,61795,809111,867383,967131,605104,375012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]