SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040171 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040171 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930183,625250,135161,572696,339063,126132,563438,471393,830058,923488,203754,228868,569329,678138,237050,434769,367252,908551,755016,229152,377267,802479,8462,381469,532028,1029963,747515,877406,632761,939671,878376,729787,609761,935335,979728,136152,781470,918336,256547,864980,204238,801304,500763,314644,858338,79294,892674,42315,884467,524635,787985,208230,951089,491723,962396,949442,974623,1002898,946609,141775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]