SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804710 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804710 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940655,347836,340781,113632,1008782,194726,72408,607068,947164,298789,410258,882778,314389,408791,299520,83934,1007297,1023741,529791,93228,263696,293489,389083,950302,613767,729610,768779,991187,909936,26572,71471,849063,929274,822035,868020,880405,621651,523894,217546,883390,835235,771502,1021465,52494,1042953,679771,83505,470173,838854,104914,369913,314714,86077,1466,876246,612694,1032444,841962,875187,1024226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]