SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409558 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409558 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629531,467961,798306,192964,552670,233220,590839,690728,649435,356620,355661,360258,461505,223397,416595,279462,1021464,234166,767287,1048578,108479,536254,7179,961276,979982,133924,43435,7013,299748,21576,202848,171083,925596,939237,791350,100244,562109,278694,974786,525511,405494,321733,635061,1010380,888768,953952,425953,893412,639603,834638,966268,904263,959907,1029409,712579,990951,106858,826605,228703,148735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]