SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504224 LIMIT 1 [ RunTime:0.002823s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504224 [ RunTime:0.001266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418039,365233,561471,663812,968299,578254,606152,258277,1039932,312613,836470,128812,573083,951285,363048,821053,373717,830036,314837,176590,648140,44447,148660,97425,83566,550663,374548,134977,922049,469410,539612,817509,408381,475317,861707,618920,396153,299526,774650,843953,619401,467579,353895,25694,31155,32256,706414,730227,156119,601224,709296,189777,845714,790059,994168,565347,248460,659843,522562,647797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]