SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459504 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459504 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154326,388670,632097,210784,247753,921277,732997,311640,249783,165261,479424,138299,1000465,968917,622632,320899,248354,471379,296864,649674,110433,725856,723766,163475,49303,135439,896163,445690,165311,391980,400275,238572,163668,111539,730265,930238,853605,548283,887672,478529,238833,7602,924323,490631,856841,75498,868041,192966,795670,833584,111159,828713,987483,389293,81341,596008,193895,483376,464381,750922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]