SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424048 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424048 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562668,439301,891524,806371,325930,1014464,600579,520027,940832,1007399,1027375,225485,342241,628105,261955,650490,141734,602521,713861,127727,959130,348647,858089,495468,514733,328383,897143,748546,925250,2382,520514,334540,1026857,443961,147999,363863,243412,863040,619240,599927,739237,263721,416603,1012557,99313,781799,348129,900172,571005,934653,380207,428522,341491,342210,435974,351308,784916,870282,148529,328856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001226s ]