SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282458 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282458 [ RunTime:0.002355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665536,262298,590907,637058,230057,860423,14807,678834,843337,422403,115950,106109,755904,569321,450661,528498,310449,671495,143541,979267,772031,239777,699503,305133,724838,156341,810760,215993,803140,72827,939187,63221,285675,1010511,550400,577472,414474,942002,379357,663140,782030,137683,47084,635189,539353,395061,493526,485817,565900,764566,181249,786225,904281,215577,460585,967188,393484,48799,307805,494098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]