SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549935 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549935 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200047,241194,839780,133971,139468,144108,582453,650949,655375,879797,602958,243086,344410,11584,111557,239470,595144,957389,229123,289534,503064,659805,851108,790541,391182,438927,536538,932441,33276,425769,91676,130375,306233,489283,465268,540284,950203,240443,770033,621142,107059,863180,572509,500786,986918,808510,898601,103153,843417,242347,856404,809244,916381,855847,99693,714749,945362,535615,1016605,572185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]