SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314303 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314303 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98699,455804,929322,239333,528022,303563,172475,854671,911870,475241,834433,583565,462403,352572,852660,177708,993990,783408,719975,207617,73057,684431,987487,993351,572461,558976,393007,1048924,277256,458110,155975,472030,533774,510504,124339,580652,583155,527261,521294,191911,498550,414640,270567,5599,557735,84693,886570,463754,784407,951286,462373,326150,238546,222903,397191,939811,1042505,189001,66322,549484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]