SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014668 LIMIT 1 [ RunTime:0.002883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014668 [ RunTime:0.006474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230916,969929,1265,194567,379293,167855,399387,576202,446001,589398,1002881,468023,912118,944601,330569,1043845,776362,399584,604017,714519,859570,40352,764774,949609,659065,154837,235418,834747,848655,1046921,134119,912031,233532,22583,790463,971067,602288,992508,615322,88338,371025,378633,552212,468245,32163,32684,175147,752994,903392,1042371,124657,345304,342412,238255,259215,255647,864913,561875,709117,164142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]