SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593851 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593851 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781512,150863,291434,948857,764985,477857,206693,54452,971831,188506,693130,763513,233871,649951,228594,26601,619384,690282,26360,46403,901178,65863,415478,121970,705995,595397,243617,825318,162442,635568,156801,63910,260844,884045,34652,125848,905031,999633,494625,649328,652883,157898,586109,692421,993414,607503,514037,631374,265579,112395,427132,750529,235056,795865,118877,24099,685730,310137,338862,139067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]