SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410595 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410595 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409811,254641,758763,279969,696055,730486,246480,875125,1025547,986345,314879,124674,454545,649656,736688,293935,490228,204491,991268,762286,1002751,891579,706770,537981,909936,325532,236744,384349,104852,840410,717387,472831,829980,140997,26153,103141,644345,497872,110680,174698,147498,455878,180761,870465,824896,966048,626493,570989,714211,312527,315618,463721,1007026,705196,948894,428251,425803,441724,332962,966481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]