SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427800 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427800 [ RunTime:0.005623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647785,724139,129445,313959,717132,348286,177405,553490,400281,353850,61138,128394,42729,313709,448499,399481,428257,1014309,551980,691155,293061,319883,103984,490943,371170,678988,232913,313662,480402,343900,35860,270730,939788,218289,41337,229216,629742,795637,306360,546000,437427,117128,303035,690791,821961,422844,590395,773034,15715,125064,157040,522011,161780,545835,908455,856172,663261,167510,329111,975644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]