SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046043 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046043 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947045,430907,201707,886120,888048,985650,786111,648096,436879,148138,524119,81584,415644,18708,111119,586956,759692,839079,483328,374882,417964,938385,1012503,431071,670664,27801,877245,1030297,368952,1042121,855833,57338,560532,141860,284437,403629,640861,525743,302645,934955,1046204,337804,803564,83359,346661,127053,185095,2742,850851,50232,774529,544777,608695,185418,341380,605971,916989,297826,718938,434596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]