SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408663 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408663 [ RunTime:0.003349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481829,587568,886808,928972,111113,554264,248988,688173,571513,630408,392062,114052,30737,996031,880540,577692,793122,58531,452562,28867,323800,366899,983662,951570,798968,662907,18769,886159,1007831,824734,608919,1028131,3829,1023953,286355,217159,291574,598817,1037846,591842,69372,984012,792825,943354,437419,945913,969307,1019453,528093,1040810,784294,441215,158436,546465,1003543,477028,728985,86744,184214,954500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001005s ]