SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421131 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421131 [ RunTime:0.001424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929202,513367,164898,694441,413664,44029,544984,650573,453565,839259,638785,586145,1012998,755784,1028053,573224,448073,140735,501587,499474,298039,164939,670725,4610,89179,694468,251701,528428,402644,33402,697869,1002146,968070,507767,776282,617583,1029514,977323,1019980,1046552,980826,588351,959005,568795,632208,135150,471510,112138,111975,502643,986525,704641,125016,263693,998040,497750,314353,918155,228803,941729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]