SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500226 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500226 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780504,43499,986848,873210,4130,714315,401837,667751,929894,1027816,886512,532504,240093,333190,138644,266191,1005716,713129,727131,1040911,310625,44731,268284,121804,916278,670526,661027,639192,26430,101313,437671,761401,37157,177951,428708,29268,636511,749136,148672,414856,127447,622856,687504,748737,568878,993229,770481,232918,867230,609214,159490,892127,116428,842480,433080,1020389,621424,193367,976522,625202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001070s ]