SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282505 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282505 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895461,865345,82315,454465,761778,909849,433398,335678,240915,532650,1043868,881890,1036562,7173,238043,400950,1038434,244062,471222,51160,421603,296256,392610,768208,164058,127693,194673,842855,669574,601005,982349,12743,109728,478504,64056,798650,895294,1850,526111,1047047,199807,903536,383418,161039,350519,1022437,939755,177034,596371,391584,455562,121259,38787,159935,1000784,937213,689774,205886,572537,789915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]