SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399860 LIMIT 1 [ RunTime:0.002775s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399860 [ RunTime:0.003596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751716,416695,134204,969488,395564,48507,191518,680463,176364,271088,1005317,385997,237336,1001878,259226,288476,741102,135723,229568,808334,74715,355591,177541,142949,1004320,765851,860814,170652,215761,197985,502870,218255,350995,712499,276995,379644,876088,837063,1024973,376216,121934,302307,76708,875756,888050,157666,32990,563901,580588,283014,759207,159879,29585,753120,298597,300159,661974,899317,329795,950175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]