SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302104 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302104 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249975,529631,193501,615352,444786,835445,1022201,393017,816883,85812,539732,136378,287326,677760,887329,939861,956498,728862,685509,1011177,7940,936837,15578,106645,446139,608838,988639,466371,604100,63630,394739,209550,304187,1005245,480185,146964,986394,900044,428653,1035179,575863,886438,705900,184339,441910,515972,594761,781546,167444,248361,60031,671093,544027,593895,337985,734622,28605,213345,669962,785353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002128s ]