SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482048 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482048 [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275127,113664,919159,805804,652348,390129,165221,967029,194883,287908,200278,45657,178704,412680,960919,828028,459574,477954,914746,480287,215680,971706,71403,1015304,224564,766865,7394,66647,405266,242639,527144,312423,1003099,986371,761546,9075,533034,677567,36980,654090,77052,550464,920006,310814,278464,831346,327793,191953,470651,39149,222098,471579,257051,572914,217385,752170,136490,314573,408048,1007607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]