SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393581 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393581 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307286,313254,143087,535027,756809,886731,266558,630829,110798,396365,50451,913799,640307,552761,827217,1027247,236504,586698,366580,539319,553615,904488,834209,624428,645082,221748,418505,101987,337833,806240,688038,368265,916674,15087,786110,428864,925200,314481,127564,150944,753105,182373,663673,11753,974662,427460,532333,438561,305536,384720,557217,217756,256158,997641,200255,218038,450570,218063,944023,950969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]