SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419156 LIMIT 1 [ RunTime:0.001116s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419156 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622372,443800,951854,962228,971173,103063,57754,107392,324131,284241,967121,68273,837180,890716,598333,699906,288484,104543,911452,52065,290878,61525,325353,320072,394560,47393,521912,432324,467416,562608,541442,436776,186471,981983,674103,607057,735394,969276,696229,781070,471533,110913,244422,1025216,518516,945366,700695,1014741,627683,902611,953898,112387,1006461,691597,491512,210762,96877,780573,794828,57217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001126s ]