SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509524 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509524 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343987,77574,893600,290288,29720,299877,343019,414267,1022315,596448,78819,1032674,398971,1010873,611558,496520,1037455,620198,267553,990828,447923,677461,671185,747800,558623,909031,172985,1004019,472956,322533,103541,976732,899217,600288,94156,143028,492096,813826,289470,211835,367539,101176,177688,34613,706735,309908,738248,651970,564839,652893,554246,671465,501588,54479,611048,184076,102370,102047,465936,1015628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]