SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482002 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482002 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24749,561104,498481,40121,512826,617529,473705,240169,218305,814541,54005,530260,319525,538469,775049,652337,58265,149819,872750,936674,506110,323053,828236,409701,202711,977403,114233,863208,146622,396969,490631,324165,993901,655709,641254,22030,791174,494822,727385,375226,1010397,532025,22863,452816,227788,775857,799047,476743,14017,203275,896023,976601,3347,802276,638734,510193,266134,484214,481224,295550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]