SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480301 LIMIT 1 [ RunTime:0.001251s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480301 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020222,830270,165065,648248,671206,1010285,806959,558110,606277,975895,711736,591855,63563,249031,884892,999051,562446,554083,912807,994344,1034951,733366,86047,777457,223317,696622,598897,445739,735414,369992,200524,996218,45426,373995,329302,1037847,659207,356845,1015445,829184,882502,833042,485705,652908,787719,380180,746668,248754,944225,180285,900675,240709,763728,986690,206538,603370,951905,417541,317037,741697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001066s ]