SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802014 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802014 [ RunTime:0.002972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495097,908887,550366,377468,511340,336129,200445,717874,974258,149874,66861,357565,821727,644608,287912,321697,570484,350980,1016685,730288,652469,439362,774059,210189,757546,348157,927577,483109,1037424,861265,157361,217740,933544,590698,1012784,606129,366469,73138,383735,324851,297509,46675,738359,826123,1041648,559218,846368,1019466,319858,836820,493091,890372,379834,210552,124844,41276,132986,983185,667380,666886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001513s ]