SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520702 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520702 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741452,97179,863392,288204,504881,414884,565686,688528,18474,709082,339362,376892,177926,165711,724113,763134,273508,551221,870555,435377,387887,931129,295825,291164,140581,1012833,248826,893462,960889,183358,840669,679890,131782,735336,25263,633429,485052,1032101,226132,951164,44674,741398,296837,953289,797661,702546,139802,9335,15145,359299,76066,116918,242917,841871,1037483,194398,680670,407077,710405,282196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]