SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409812 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409812 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019461,834683,1046507,944294,120067,205316,80071,711319,930925,847014,574687,148196,740300,494332,1034995,678673,662350,790637,23035,652995,803053,155070,332842,193272,442629,179932,134912,951087,795023,804730,984863,701237,138097,871774,444695,90324,798889,233060,948956,1032805,394890,97754,817334,714694,372605,88978,736838,306936,831018,835912,999697,280239,373058,539381,319499,6472,45123,132353,795720,956119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]