SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290411 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290411 [ RunTime:0.002505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683435,31631,73582,453609,352636,415670,535402,4922,295279,454644,615488,147921,389930,300931,950520,681829,863448,357886,878316,934143,349944,574861,353159,265269,199098,690670,912721,562523,554354,291386,723694,872044,714990,59361,433399,224066,515358,232510,757113,1022658,708262,947380,658776,902095,316755,257246,942841,748970,509003,259174,720636,51581,672618,153443,429212,541833,412357,50312,580331,776145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]