SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382563 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382563 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560008,586670,5193,567146,884836,351553,856518,838003,933215,324459,563109,532261,731729,185301,134896,999680,257944,554727,654294,929795,89255,970893,596070,572801,65600,574567,1035965,255258,562585,964245,324228,662628,433519,841426,851007,669788,1046454,414739,317638,319691,347711,277846,1034167,831870,757641,714083,63591,943552,855713,4469,393342,209684,889318,396282,846756,556219,1015484,489297,246181,891778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]