SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 969343 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 969343 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510030,395346,890115,596472,1026909,840983,753990,727516,155123,395825,582051,1001770,324894,147889,485146,545794,673489,35259,318861,622893,699588,379720,664943,999570,544832,666058,628533,227238,566798,103561,410054,376759,54199,580046,929737,554555,214413,906461,153795,143950,388974,609151,224644,408586,560506,484927,8551,513224,1040630,433545,254550,125140,441182,150816,1043807,8477,351182,251566,893196,475602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 969343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 969343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]