SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42951 LIMIT 1 [ RunTime:0.002885s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42951 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475364,201997,401660,127846,761747,217989,653865,878044,469627,725729,6446,852818,822554,126368,510192,779361,141097,501204,626995,1024539,87300,259660,679727,78386,851799,830851,722824,925533,337537,315012,419431,374582,581496,187610,436126,305563,605925,206701,81391,236748,4110,1025538,476467,985497,587495,266891,928878,110185,685435,1035103,321171,596979,407965,62136,358914,128509,188938,658793,550413,106484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001029s ]