SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901508 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901508 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475632,378041,736134,530576,508452,988261,170655,236761,302876,247029,1015633,486079,739263,373747,95838,510502,84619,52368,234615,398729,189747,894289,111274,131653,796538,678309,989459,64019,872056,984479,639767,998974,558259,477947,336243,45639,7532,27284,588717,50899,453102,60376,782276,62068,856972,412165,546355,593168,945007,541755,3397,71501,183015,1039503,848826,378412,465139,937099,213174,504049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]