SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675013 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675013 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481314,1042067,259691,310512,1001365,897407,108352,551417,1019,70621,569393,1003606,212956,77937,664327,217186,278946,1019585,161245,725091,905700,603767,471196,637693,50259,486847,6265,294845,137866,864066,870825,971553,415773,208403,735190,520077,279608,413753,710153,445796,196531,250218,687417,152680,1031218,894848,157035,510053,437787,473185,742713,987927,827030,124842,942112,161622,616113,957092,903328,657414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]