SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124810 LIMIT 1 [ RunTime:0.001726s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124810 [ RunTime:0.004637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892063,74319,206675,277310,275062,714182,370001,866452,399859,1045599,519186,594568,760183,848632,361327,1030660,937510,585369,451638,748935,110028,53825,14940,306640,494896,735672,360649,1021869,929462,271586,889009,523657,1030758,180602,675425,132889,800054,902446,358669,186167,937449,342106,808057,363130,96265,853979,326502,488352,938753,168846,1015482,554659,117284,70770,517288,814024,202696,331054,712492,458599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]