SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451254 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451254 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465713,153276,861244,852589,500982,306284,664088,966553,523294,537630,909537,807524,1035663,594035,645452,673921,412350,334519,263703,583624,407336,919423,534229,698156,555226,1027101,602424,821795,38538,1003493,506009,8035,154238,1007315,844532,536485,711506,523497,416823,1035617,892272,413226,950339,1031417,363056,228810,282795,142948,756673,67793,788656,307657,119678,386488,349208,100205,718883,235677,713516,103220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]