SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432155 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432155 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806991,235531,635908,187960,17102,686478,951772,71686,622569,867578,509822,1043561,929897,512798,605386,708023,471342,761950,804598,710729,552910,853767,1014380,672641,1041725,1040755,934669,44345,128440,521846,232953,345389,560064,440094,1027082,830102,637387,181212,652367,957887,236695,1022980,806081,804562,674408,662121,616554,984658,896791,491817,306051,238745,812573,288400,39343,773823,862343,741720,946438,688944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432155 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432155 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]