SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043797 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043797 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562687,346117,569504,289035,923275,979734,174203,325210,136731,785517,97256,907681,259813,763102,530603,1032461,510349,275402,1026967,411564,755539,203313,78543,579844,153640,1043251,979679,11897,192889,692660,976302,176088,567549,680931,520742,505393,191992,939827,788376,156637,219878,167473,933669,515884,592693,227840,1036691,290731,371901,119791,498673,823413,331557,950361,625200,291108,840569,269439,388709,393611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002686s ]