SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003722s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483427 LIMIT 1 [ RunTime:0.005007s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483427 [ RunTime:0.005676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446754,139534,297313,397426,117481,682082,235802,227321,304575,603936,139451,933213,544787,231468,120353,630433,566798,851259,931892,91799,759826,196690,965354,526414,1023430,582400,225001,904095,1009721,834937,840572,172524,126382,426122,222535,959833,652922,635175,764011,758829,668320,664732,655508,742258,744816,197935,486478,545442,891825,1012522,123867,571044,1023937,747500,598678,823898,165484,736984,64356,694238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007281s ]